Release 10.1A: OpenEdge Data Management:
SQL Development

Working with data type compatibility

While all 4GL data types are supported by SQL equivalents, Table 7–1 illustrates the compatible data types of the two languages.

Table 7–1: Progress 4GL and OpenEdge SQL data types  

Progress 4GL data type	OpenEdge SQL data type
ARRAY	ARRAY, VARARRAY
BLOB	LVARBINARY, BLOB
CHARACTER	VARCHAR, CHAR
CLOB	CLOB, LVARCHAR
DATE	DATE
DATETIME	TIMESTAMP
DATETIME-TZ	TIMESTAMP WITH TIME ZONE
DECIMAL	DECIMAL or NUMERIC
INTEGER	INTEGER
LOGICAL	BIT
RAW	VARBINARY
RECID	INTEGER

For information on Progress 4GL data types, see OpenEdge Development: Progress 4GL Handbook . For more information on OpenEdge SQL data types, see OpenEdge Data Management: SQL Reference .